BEGIN TRANSACTION GO ALTER TABLE dbo.gen_ProductsInfo ADD WH1 numeric(12, 0) NOT NULL CONSTRAINT DF_gen_ProductsInfo_WH1 DEFAULT 0, WH2 numeric(12, 0) NOT NULL CONSTRAINT DF_gen_ProductsInfo_WH2 DEFAULT 0, WH3 numeric(12, 0) NOT NULL CONSTRAINT DF_gen_ProductsInfo_WH3 DEFAULT 0 GO COMMIT ---------------------------- BEGIN TRANSACTION GO ALTER TABLE dbo.data_SalesDetail ADD RateList tinyint NOT NULL CONSTRAINT DF_data_SalesDetail_RateList DEFAULT 0 GO COMMIT ----------------------------